<%@ page language="java" import="java.sql.*,util.*" pageEncoding="utf-8"%>
<%@ include file="SessionCheck.jsp" %>
<%
String sid=student.getId();
DBConnection db=new DBConnection();
String sql="select * from submition where sid='"+sid+"'";
ResultSet rs=db.executeQuery(sql);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'scores.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
  <div align="center">
  <% 
  while(rs!=null&&rs.next()){
  %>
    <table width="745" border="0">
      <tr>
        <td width="1012">作业编号：<%=rs.getString("id") %></td>
      </tr>
      <tr>
        <td>文件名：<%=rs.getString("filename") %></td>
      </tr>
      <tr>
        <td>描述：<%=rs.getString("description") %></td>
      </tr>
      <tr>
        <td>是否已批改：<%=rs.getString("status") %></td>
      </tr>
      <tr>
        <td>得分：<%=rs.getString("score") %></td>
      </tr>
      <tr>
        <td>评语：<%=rs.getString("remark") %></td>
      </tr>
      </table>
      <%} 
      db.close(rs);
      db.close();
      %>
  </div>
  </body>
</html>
